Course code |
07 67 4020 17 |
ECTS credits |
6 |
Course title in the language of instruction |
Fundamentals of Databases |
Course title in Polish |
Fundamentals of Databases (Podstawy baz danych) |
Course title in English |
Fundamentals of Databases |
Language of instruction |
English |
Course level |
first-cycle programme |
Course coordinator |
dr inż. Krzysztof Myszkorowski, dr hab. inż. Agnieszka Wosiak |
Course instructors |
dr hab. inż. Przemysław Ignaciuk, dr hab. inż. Agnieszka Wosiak |
Delivery methods and course duration |
|
Lecture |
Tutorials |
Laboratory |
Project |
Seminar |
Other |
Total of teaching hours during semester |
Contact hours |
30 |
|
30 |
|
|
0 |
60 |
E-learning |
No |
No |
No |
No |
No |
No |
|
Assessment criteria (weightage) |
0.55 |
|
0.45 |
|
|
0.00 |
|
|
Course objective |
- The course covers issues regarding basic concepts in the field of database systems, presents the methodology of modeling and designing databases and describes the way of processing queries in a relational data model. The issues discussed are covered by practical exercises.
|
Learning outcomes |
- A student who completed the course can design a logical database structure in accordance with the indicated requirements.
- A student who completed the course can formulate queries using relation algebra operators and SQL.
- A student who completed the course can implement and describe a relational database.
|
Assessment methods |
Written exam (learning outcomes 1. and 2.)
Laboratory test learning outcomes 2. and 3.)
Reports during laboratory classess learning outcomes 1., 2. and 3.)
|
Prerequisites |
Mathematics |
Course content with delivery methods |
LECTURE
Lectures include the following issues:
1. Architecture of the Database Management System
2. Data models. Entity-Relationship Model
3. Relational databases. Functional dependencies and normalization
4. Relational Algebra
5. SQL - Structured Query Language
6. Transaction Management
LABORATORY
During laboratory classes students perform exercises related to issues, which are discussed during lectures. |
Basic reference materials |
- Elmasri R., Navathe S.: Fundamentals of Database Systems. (7th edition), Pearson, 2015
- Ullman J., Widom J.:First Course in Database Systems. (3rd edition) Pearson, 2014
- Garcia-Molina H., Ullman J., Widom J.: Database systems. The complete book. (2nd edition), Pearson, 2014
- Connolly T., Begg C.: Database Systems: A Practical Approach to Design, Implementation, and Management. (6th edition) Pearson, 2015
- Date C. J.: Introduction to Database Systems. (8th edition) Pearson, 2006
- Hoffer J., Ramesh. V. Topi H.: Modern Database Management, 13th Edition, Pearson 2019
|
Other reference materials |
- Bagui S.: Database design using entity-relationship diagrams. CRC Press/Taylor&Francis Group/An Auerbach Book, 2012
- Teorey T.J.: Database modeling and design : logical design. Morgan Kaufmann Publishers is an imprint of Elsevier, 2011
|
Average student workload outside classroom |
116 |
Comments |
|
Last update |
2020-02-28 11:52:30 |